﻿using System;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;

namespace BRMC.IntelligentCommunity.Migrations
{
    public partial class add_tb : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            //migrationBuilder.DropTable(
            //    name: "App_role");

            //migrationBuilder.DropTable(
            //    name: "App_role_rule");

            //migrationBuilder.DropTable(
            //    name: "App_rule");

            //migrationBuilder.DropTable(
            //    name: "App_user");

            //migrationBuilder.DropTable(
            //    name: "App_user_dep_role");

            //migrationBuilder.DropTable(
            //    name: "Bb_by_agenter_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_price_package");

            //migrationBuilder.DropTable(
            //    name: "Bb_staff_work_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_agent_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_buy_flow");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_buy_install_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_buy_log");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_buy_product");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_evaluate_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_evaluate_pict");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_renewal_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_renewal_log");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_repairs_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_repairs_install_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_repairs_log");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_service_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_service_install_info");

            //migrationBuilder.DropTable(
            //    name: "Bb_user_service_log");

            //migrationBuilder.DropTable(
            //    name: "product_info");

            //migrationBuilder.DropTable(
            //    name: "Sys_banner");

            //migrationBuilder.DropTable(
            //    name: "Sys_data_set");

            //migrationBuilder.DropTable(
            //    name: "Sys_house_chart");

            //migrationBuilder.DropTable(
            //    name: "Sys_house_info");

            //migrationBuilder.DropTable(
            //    name: "Sys_information");

            //migrationBuilder.DropTable(
            //    name: "Sys_neighbourhood_info");

            //migrationBuilder.DropTable(
            //    name: "Sys_notice");

            //migrationBuilder.DropTable(
            //    name: "Sys_site_dict");

            //migrationBuilder.DropTable(
            //    name: "Sys_site_dict_index");

            //migrationBuilder.DropTable(
            //    name: "Sys_verification_code");

            //migrationBuilder.DropTable(
            //    name: "User_apply_reside_info");

            //migrationBuilder.DropTable(
            //    name: "User_broadband_info");

            //migrationBuilder.DropTable(
            //    name: "User_excel_import_tmp");

            //migrationBuilder.DropTable(
            //    name: "User_house_info");

            //migrationBuilder.DropTable(
            //    name: "User_idcard_pict_info");

            //migrationBuilder.DropTable(
            //    name: "User_pay_info");

            //migrationBuilder.DropTable(
            //    name: "User_sys_info");

            //migrationBuilder.DropTable(
            //    name: "User_wechat_info");

            //migrationBuilder.DropTable(
            //    name: "Vote");

            //migrationBuilder.DropTable(
            //    name: "Vote_items");

            //migrationBuilder.DropTable(
            //    name: "Vote_user_log");

            //migrationBuilder.DropTable(
            //    name: "Work_evaluate_info");

            //migrationBuilder.DropTable(
            //    name: "Work_wechat_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_facility_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_material_tool_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_material_tool_inout_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_repairs_equipment_class");

            //migrationBuilder.DropTable(
            //    name: "Wy_repairs_work_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_evaluate_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_evaluate_pict");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_repairs_comments_info");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_repairs_list");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_repairs_log");

            //migrationBuilder.DropTable(
            //    name: "Wy_user_repairs_praise");

            //migrationBuilder.DropTable(
            //    name: "Wy_work_evaluate_info");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            //migrationBuilder.CreateTable(
            //    name: "App_role",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Ar_type = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Title = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_App_role", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "App_role_rule",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Roleid = table.Column<int>(nullable: false),
            //        Ruleid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_App_role_rule", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "App_rule",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Icon = table.Column<string>(nullable: true),
            //        Pid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Rule = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Title = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_App_rule", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "App_user",
            //    columns: table => new
            //    {
            //        Id = table.Column<long>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        AvatarUrl = table.Column<string>(nullable: true),
            //        City = table.Column<string>(nullable: true),
            //        Country = table.Column<string>(nullable: true),
            //        Gender = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Language = table.Column<string>(nullable: true),
            //        NickName = table.Column<string>(nullable: true),
            //        Openid = table.Column<string>(nullable: true),
            //        Province = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Unionid = table.Column<string>(nullable: true),
            //        Userid = table.Column<long>(nullable: false),
            //        Usertype = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_App_user", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "App_user_dep_role",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Depid = table.Column<int>(nullable: false),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Roleid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_App_user_dep_role", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_by_agenter_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Address = table.Column<string>(nullable: true),
            //        Dh = table.Column<string>(nullable: true),
            //        Dy = table.Column<string>(nullable: true),
            //        Fh = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Neig_id = table.Column<int>(nullable: false),
            //        Op_date = table.Column<DateTime>(nullable: true),
            //        Phone = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_by_agenter_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_price_package",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Bandwidth = table.Column<int>(nullable: false),
            //        Content = table.Column<string>(nullable: true),
            //        Icon = table.Column<string>(nullable: true),
            //        Icon_path = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Money = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Name = table.Column<string>(nullable: true),
            //        Original_money = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Pid = table.Column<int>(nullable: false),
            //        Presenter_month = table.Column<int>(nullable: false),
            //        Presenter_other = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        Sort = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Time_long = table.Column<int>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_price_package", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_staff_work_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Buy_accept = table.Column<int>(nullable: false, defaultValue: 0),
            //        Buy_finish = table.Column<int>(nullable: false, defaultValue: 0),
            //        Buy_nofinish = table.Column<int>(nullable: false, defaultValue: 0),
            //        New_accept = table.Column<int>(nullable: false, defaultValue: 0),
            //        New_finish = table.Column<int>(nullable: false, defaultValue: 0),
            //        New_nofinish = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Renewal_finish = table.Column<int>(nullable: false, defaultValue: 0),
            //        Repairs_accept = table.Column<int>(nullable: false, defaultValue: 0),
            //        Repairs_finish = table.Column<int>(nullable: false, defaultValue: 0),
            //        Repairs_nofinish = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_staff_work_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_agent_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Agent_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Bizid = table.Column<int>(nullable: false),
            //        Btype = table.Column<int>(nullable: false, defaultValue: 1),
            //        By_agenter_id = table.Column<int>(nullable: false),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_agent_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_buy_flow",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Buyid = table.Column<int>(nullable: false),
            //        Discount_price = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Price = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Product_id = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Unit_price = table.Column<decimal>(type: "decimal(18,2)", nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_buy_flow", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_buy_install_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale__time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        After_sale_name = table.Column<string>(nullable: true),
            //        After_sale_openid = table.Column<string>(nullable: true),
            //        After_sale_remark = table.Column<string>(nullable: true),
            //        Bbid = table.Column<int>(nullable: false),
            //        Customer_service_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Customer_service_name = table.Column<string>(nullable: true),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_remark = table.Column<string>(nullable: true),
            //        Finish_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Work_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Work_name = table.Column<string>(nullable: true),
            //        Work_openid = table.Column<string>(nullable: true),
            //        Work_remark = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_buy_install_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_buy_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Bbid = table.Column<int>(nullable: false),
            //        Name = table.Column<string>(nullable: true),
            //        Operation = table.Column<int>(nullable: false),
            //        Operator = table.Column<int>(nullable: false),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        User_type = table.Column<string>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_buy_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_buy_product",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Appointment_date = table.Column<string>(nullable: true),
            //        Appointment_time_end = table.Column<string>(nullable: true),
            //        Appointment_time_start = table.Column<string>(nullable: true),
            //        Bbid = table.Column<int>(nullable: false),
            //        Buy_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change_u = table.Column<int>(nullable: false, defaultValue: 0),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Discount_price = table.Column<decimal>(type: "decimal(20,2)", nullable: false),
            //        Finish_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Payid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Price = table.Column<decimal>(type: "decimal(20,2)", nullable: false),
            //        Product_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Service_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        Type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Unit_price = table.Column<decimal>(type: "decimal(20,2)", nullable: false),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_buy_product", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_evaluate_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_sorce = table.Column<int>(nullable: false, defaultValue: 0),
            //        Finish_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        Service_content = table.Column<string>(nullable: true),
            //        Service_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Status = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Work_openid = table.Column<string>(nullable: true),
            //        Work_sorce = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_evaluate_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_evaluate_pict",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Evaluate_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Pictname = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_evaluate_pict", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_renewal_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accepted_date = table.Column<string>(nullable: true),
            //        Bbid = table.Column<int>(nullable: false),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Due_date = table.Column<string>(nullable: true),
            //        Duration = table.Column<int>(nullable: false),
            //        Finish_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Opdate = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Openid = table.Column<string>(nullable: true),
            //        Operator = table.Column<string>(nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Paytype = table.Column<int>(nullable: false, defaultValue: 0),
            //        Price_package_id = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        Total = table.Column<decimal>(type: "decimal(10,2)", nullable: false),
            //        Upid = table.Column<int>(nullable: false),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_renewal_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_renewal_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Name = table.Column<string>(nullable: true),
            //        Operation = table.Column<int>(nullable: false),
            //        Operator = table.Column<int>(nullable: false),
            //        Remark = table.Column<string>(nullable: true),
            //        Renewal_id = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        User_type = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_renewal_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_repairs_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Appointment_date = table.Column<string>(nullable: true),
            //        Appointment_time_end = table.Column<string>(nullable: true),
            //        Appointment_time_start = table.Column<string>(nullable: true),
            //        Bbid = table.Column<int>(nullable: false),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change_u = table.Column<int>(nullable: false, defaultValue: 0),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Finish_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Price_package_id = table.Column<int>(nullable: false),
            //        Remark = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        TimeStamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Work_order_no = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_repairs_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_repairs_install_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale__time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        After_sale_name = table.Column<string>(nullable: true),
            //        After_sale_openid = table.Column<string>(nullable: true),
            //        After_sale_remark = table.Column<string>(nullable: true),
            //        Customer_service_id = table.Column<int>(nullable: false),
            //        Customer_service_name = table.Column<string>(nullable: true),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_remark = table.Column<string>(nullable: true),
            //        Finish_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Repairs_id = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Work_id = table.Column<int>(nullable: false),
            //        Work_name = table.Column<string>(nullable: true),
            //        Work_openid = table.Column<string>(nullable: true),
            //        Work_remark = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_repairs_install_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_repairs_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Name = table.Column<string>(nullable: true),
            //        Operation = table.Column<int>(nullable: false, defaultValue: 0),
            //        Operator = table.Column<int>(nullable: false, defaultValue: 0),
            //        Remark = table.Column<string>(nullable: true),
            //        Repairsid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        User_type = table.Column<string>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_repairs_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_service_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Appointment_date = table.Column<string>(nullable: true),
            //        Appointment_time_end = table.Column<string>(nullable: true),
            //        Appointment_time_start = table.Column<string>(nullable: true),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change_u = table.Column<int>(nullable: false, defaultValue: 0),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Finish_date = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Payid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Price_package_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Remark = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        TimeStamp = table.Column<DateTime>(maxLength: 50, nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_service_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_service_install_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale__time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        After_sale_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        After_sale_name = table.Column<string>(nullable: true),
            //        After_sale_openid = table.Column<string>(nullable: true),
            //        After_sale_remark = table.Column<string>(nullable: true),
            //        Customer_service_id = table.Column<int>(nullable: false),
            //        Customer_service_name = table.Column<string>(nullable: true),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_remark = table.Column<string>(nullable: true),
            //        Finish_time = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        Service_id = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Work_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Work_name = table.Column<string>(nullable: true),
            //        Work_openid = table.Column<string>(nullable: true),
            //        Work_remark = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_service_install_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Bb_user_service_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Name = table.Column<string>(nullable: true),
            //        Operation = table.Column<int>(nullable: false, defaultValue: 1),
            //        Operator = table.Column<int>(nullable: false, defaultValue: 0),
            //        Remark = table.Column<int>(nullable: false),
            //        Serviceid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(maxLength: 50, nullable: true),
            //        User_type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Bb_user_service_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "product_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Describe = table.Column<string>(nullable: true),
            //        Discount = table.Column<decimal>(type: "decimal(10,2)", nullable: false),
            //        Icon = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Largeclass = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Price = table.Column<decimal>(type: "decimal(10,2)", nullable: false),
            //        Sort = table.Column<int>(nullable: false, defaultValue: 1),
            //        Subclass = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_product_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_banner",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Sort = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Url = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_banner", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_data_set",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Desc = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Unit = table.Column<string>(nullable: true),
            //        Value = table.Column<int>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_data_set", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_house_chart",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Files = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_house_chart", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_house_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        All = table.Column<string>(nullable: true),
            //        Chart = table.Column<int>(nullable: false, defaultValue: 0),
            //        Floor = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Neighbourhood_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        P_num = table.Column<int>(nullable: false, defaultValue: 1),
            //        Ridgepole = table.Column<string>(nullable: true),
            //        Room_num = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Unit = table.Column<string>(nullable: true),
            //        Use_status = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_house_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_information",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Author = table.Column<string>(nullable: true),
            //        Content = table.Column<string>(nullable: true),
            //        Date = table.Column<DateTime>(nullable: false),
            //        Filename = table.Column<string>(nullable: true),
            //        Icon = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Pict_path = table.Column<string>(nullable: true),
            //        Reads = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Title = table.Column<string>(nullable: true),
            //        Top = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_information", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_neighbourhood_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Companyid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Family = table.Column<int>(nullable: false, defaultValue: 0),
            //        Iscover = table.Column<int>(nullable: false, defaultValue: 1),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Latitude = table.Column<decimal>(type: "decimal(10,6)", nullable: false),
            //        Longitude = table.Column<decimal>(type: "decimal(10,6)", nullable: false),
            //        Name = table.Column<string>(nullable: true),
            //        Ridgepole = table.Column<int>(nullable: false, defaultValue: 0),
            //        Site = table.Column<string>(nullable: true),
            //        Span_class = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        Xq_pin_yin = table.Column<string>(nullable: true),
            //        Xq_py = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_neighbourhood_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_notice",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Clicks = table.Column<int>(nullable: false, defaultValue: 0),
            //        Content = table.Column<string>(nullable: true),
            //        File_name = table.Column<string>(nullable: true),
            //        File_url = table.Column<string>(nullable: true),
            //        Img_name = table.Column<string>(nullable: true),
            //        Img_url = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(nullable: false),
            //        Title = table.Column<string>(nullable: true),
            //        Top = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_notice", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_site_dict",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Index = table.Column<int>(nullable: false, defaultValue: 0),
            //        Is_del = table.Column<int>(nullable: false, defaultValue: 0),
            //        Keyword = table.Column<string>(nullable: true),
            //        Note = table.Column<string>(nullable: true),
            //        Relevant_val = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Remark = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Value = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_site_dict", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_site_dict_index",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Is_del = table.Column<int>(nullable: false, defaultValue: 0),
            //        Note = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_site_dict_index", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Sys_verification_code",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Code = table.Column<int>(nullable: false),
            //        Creat_time = table.Column<int>(nullable: false),
            //        Expire_time = table.Column<int>(nullable: false),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Phone = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Sys_verification_code", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_apply_reside_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Address = table.Column<string>(nullable: true),
            //        Apply_time = table.Column<DateTime>(nullable: false),
            //        Apply_type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Audit_time = table.Column<DateTime>(nullable: false),
            //        Auditor = table.Column<string>(nullable: true),
            //        Auditor_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Authority = table.Column<string>(nullable: true),
            //        Birth = table.Column<string>(nullable: true),
            //        City = table.Column<string>(nullable: true),
            //        DetailedAddress = table.Column<string>(nullable: true),
            //        Gender = table.Column<string>(nullable: true),
            //        Idcardno = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Nationality = table.Column<string>(nullable: true),
            //        Neighbourhood = table.Column<string>(nullable: true),
            //        Openid = table.Column<string>(nullable: true),
            //        P_num = table.Column<int>(nullable: false, defaultValue: 1),
            //        Phone = table.Column<string>(nullable: true),
            //        Province = table.Column<string>(nullable: true),
            //        PurePhoneNumber = table.Column<string>(nullable: true),
            //        Reason = table.Column<string>(nullable: true),
            //        Region = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Type = table.Column<string>(nullable: true),
            //        Use_status = table.Column<int>(nullable: false, defaultValue: 0),
            //        Valid_date = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_apply_reside_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_broadband_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accepted_date = table.Column<string>(nullable: true),
            //        Bandwidth = table.Column<int>(nullable: false, defaultValue: 0),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Charges = table.Column<decimal>(nullable: false),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Due_date = table.Column<string>(nullable: true),
            //        Duration = table.Column<int>(nullable: false, defaultValue: 0),
            //        Gm_money = table.Column<string>(nullable: true),
            //        Goods_income = table.Column<string>(nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Jdh_money = table.Column<string>(nullable: true),
            //        Lyq_money = table.Column<string>(nullable: true),
            //        Name = table.Column<string>(nullable: true),
            //        Opdate = table.Column<DateTime>(nullable: false),
            //        Openid = table.Column<string>(nullable: true),
            //        Operator = table.Column<string>(nullable: true),
            //        Present = table.Column<string>(nullable: true),
            //        Price_package_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Remark = table.Column<string>(nullable: true),
            //        Service_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Type = table.Column<int>(nullable: false, defaultValue: 1),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L),
            //        Userid_base = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_broadband_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_excel_import_tmp",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Addrees = table.Column<string>(nullable: true),
            //        Bandwidth = table.Column<string>(nullable: true),
            //        Bb_money = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Begin_date = table.Column<string>(nullable: true),
            //        Biz_type = table.Column<string>(nullable: true),
            //        Duration = table.Column<string>(nullable: true),
            //        End_date = table.Column<string>(nullable: true),
            //        Excel_name = table.Column<string>(nullable: true),
            //        Gm_money = table.Column<string>(nullable: true),
            //        Goods_income = table.Column<string>(nullable: true),
            //        Jdh_money = table.Column<string>(nullable: true),
            //        Lyq_money = table.Column<string>(nullable: true),
            //        Name = table.Column<string>(nullable: true),
            //        Operator = table.Column<int>(nullable: false, defaultValue: 0),
            //        Opname = table.Column<string>(nullable: true),
            //        Pay_type = table.Column<string>(nullable: true),
            //        Phone = table.Column<string>(nullable: true),
            //        Realname = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Total = table.Column<string>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_excel_import_tmp", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_house_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Applyid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Houseid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Numbers = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_house_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_idcard_pict_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Apply_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Idcard_a = table.Column<string>(nullable: true),
            //        Idcard_b = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_idcard_pict_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_pay_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        By_agent_userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Description = table.Column<string>(nullable: true),
            //        Detailadd = table.Column<string>(nullable: true),
            //        Isagent = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Out_trade_no = table.Column<string>(nullable: true),
            //        Payment_method = table.Column<int>(nullable: false, defaultValue: 1),
            //        Price_package_id = table.Column<int>(nullable: false, defaultValue: 1),
            //        Remark = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(nullable: false),
            //        Total = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_pay_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_sys_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Evaluate_broadband = table.Column<int>(nullable: false, defaultValue: 0),
            //        Newmsgs = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_sys_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "User_wechat_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        CountryCode = table.Column<string>(nullable: true),
            //        Gender = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        PhoneNumber = table.Column<string>(nullable: true),
            //        PurePhoneNumber = table.Column<string>(nullable: true),
            //        Region = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_User_wechat_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Vote",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Allvotes = table.Column<int>(nullable: false, defaultValue: 0),
            //        Describe = table.Column<string>(nullable: true),
            //        Endtime = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isshow = table.Column<int>(nullable: false, defaultValue: 1),
            //        Itemnum = table.Column<int>(nullable: false, defaultValue: 0),
            //        Mancount = table.Column<int>(nullable: false, defaultValue: 0),
            //        Maxoptionnum = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<int>(nullable: false, defaultValue: 0),
            //        Title = table.Column<string>(nullable: true),
            //        Turnout = table.Column<float>(nullable: false),
            //        Userid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Votecount = table.Column<int>(nullable: false, defaultValue: 0),
            //        Voterange = table.Column<int>(nullable: false, defaultValue: 0),
            //        Votetype = table.Column<int>(nullable: false, defaultValue: 1),
            //        Womancount = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Vote", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Vote_items",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Item = table.Column<string>(nullable: true),
            //        Percent = table.Column<float>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Voteid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Votenum = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Vote_items", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Vote_user_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isvote = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Voteid = table.Column<int>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Vote_user_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Work_evaluate_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Bb_evaluate_number = table.Column<int>(nullable: false, defaultValue: 0),
            //        Bb_score = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        Bb_total_score = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Work_evaluate_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Work_wechat_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        CountryCode = table.Column<string>(nullable: true),
            //        Gender = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Optime = table.Column<DateTime>(nullable: false),
            //        PhoneNumber = table.Column<string>(nullable: true),
            //        PurePhoneNumber = table.Column<string>(nullable: true),
            //        Region = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false, defaultValue: 0L)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Work_wechat_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_facility_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Classid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Latitude = table.Column<string>(nullable: true),
            //        Location = table.Column<string>(nullable: true),
            //        Longitude = table.Column<string>(nullable: true),
            //        Neig_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Number = table.Column<string>(nullable: true),
            //        Qrcode_url = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Title = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_facility_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_material_tool_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Amount = table.Column<int>(nullable: false, defaultValue: 0),
            //        Classid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Operater = table.Column<int>(nullable: false, defaultValue: 0),
            //        Opname = table.Column<string>(nullable: true),
            //        Optime = table.Column<DateTime>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Type = table.Column<int>(nullable: false, defaultValue: 0)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_material_tool_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_material_tool_inout_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Biztype = table.Column<int>(nullable: false, defaultValue: 1),
            //        Getdate = table.Column<DateTime>(nullable: false),
            //        Inout = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Itemid = table.Column<int>(nullable: false),
            //        Keeper = table.Column<int>(nullable: false, defaultValue: 0),
            //        Mtid = table.Column<int>(nullable: false),
            //        Optime = table.Column<DateTime>(nullable: false),
            //        Remark_k = table.Column<string>(nullable: true),
            //        Remark_w = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true),
            //        Workerid = table.Column<int>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_material_tool_inout_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_repairs_equipment_class",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isprivate = table.Column<int>(nullable: false, defaultValue: 0),
            //        Name = table.Column<string>(nullable: true),
            //        Pid = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_repairs_equipment_class", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_repairs_work_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(nullable: true),
            //        Arrive_time = table.Column<DateTime>(nullable: true),
            //        Customer_service_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Customer_service_name = table.Column<string>(nullable: true),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_remark = table.Column<string>(nullable: true),
            //        Finish_time = table.Column<DateTime>(nullable: true),
            //        Latitude = table.Column<string>(nullable: true),
            //        Longitude = table.Column<string>(nullable: true),
            //        Repairsid = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Work_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Work_name = table.Column<string>(nullable: true),
            //        Work_openid = table.Column<string>(nullable: true),
            //        Work_remark = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_repairs_work_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_evaluate_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Accept_time = table.Column<DateTime>(nullable: false),
            //        Bizid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Biztype = table.Column<int>(nullable: false, defaultValue: 1),
            //        Customer_service_openid = table.Column<string>(nullable: true),
            //        Customer_service_sorce = table.Column<int>(nullable: false, defaultValue: 0),
            //        Finish_time = table.Column<DateTime>(nullable: false),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Remark = table.Column<string>(nullable: true),
            //        Repairs_openid = table.Column<string>(nullable: true),
            //        Repairs_sorce = table.Column<int>(nullable: false, defaultValue: 0),
            //        TenantId = table.Column<int>(nullable: true),
            //        Timestamp = table.Column<DateTime>(nullable: false),
            //        Work_order_no = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_evaluate_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_evaluate_pict",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Evaluate_id = table.Column<int>(nullable: false),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Pictname = table.Column<string>(nullable: true),
            //        TenantId = table.Column<int>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_evaluate_pict", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_repairs_comments_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Comments_date = table.Column<DateTime>(nullable: false),
            //        Content = table.Column<string>(nullable: true),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Repairsid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_repairs_comments_info", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_repairs_list",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Address = table.Column<string>(nullable: true),
            //        Appt_b_time = table.Column<string>(nullable: true),
            //        Appt_date = table.Column<string>(nullable: true),
            //        Appt_e_time = table.Column<string>(nullable: true),
            //        Classid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Comments_times = table.Column<int>(nullable: false, defaultValue: 0),
            //        Compid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change_u = table.Column<int>(nullable: false, defaultValue: 0),
            //        Date_change_w = table.Column<int>(nullable: false, defaultValue: 0),
            //        Eval_status = table.Column<int>(nullable: false, defaultValue: 0),
            //        Fa_type = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isaudit = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Isshow = table.Column<int>(nullable: false, defaultValue: 0),
            //        Lat = table.Column<string>(nullable: true),
            //        Lng = table.Column<string>(nullable: true),
            //        Neig_id = table.Column<int>(nullable: false, defaultValue: 0),
            //        Op_date = table.Column<DateTime>(nullable: false),
            //        Openid = table.Column<string>(nullable: true),
            //        Praise_times_u = table.Column<int>(nullable: false, defaultValue: 0),
            //        Praise_times_w = table.Column<int>(nullable: false, defaultValue: 0),
            //        Re_date = table.Column<DateTime>(nullable: false),
            //        Remark = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        UserName = table.Column<string>(nullable: true),
            //        UserPhone = table.Column<string>(nullable: true),
            //        Userid = table.Column<long>(nullable: false),
            //        Work_order_no = table.Column<string>(nullable: true)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_repairs_list", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_repairs_log",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Optime = table.Column<DateTime>(nullable: false),
            //        Remark = table.Column<string>(nullable: true),
            //        Repairsid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Servicerid = table.Column<int>(nullable: false, defaultValue: 0),
            //        Sname = table.Column<string>(nullable: true),
            //        Status = table.Column<int>(nullable: false, defaultValue: 1),
            //        TenantId = table.Column<int>(nullable: true),
            //        User_type = table.Column<int>(nullable: false, defaultValue: 1)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_repairs_log", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_user_repairs_praise",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Isdel = table.Column<int>(nullable: false, defaultValue: 0),
            //        Ispraise = table.Column<int>(nullable: false, defaultValue: 1),
            //        Openid = table.Column<string>(nullable: true),
            //        Optime = table.Column<DateTime>(nullable: false),
            //        Ptype = table.Column<int>(nullable: false, defaultValue: 0),
            //        Repairsid = table.Column<int>(nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Userid = table.Column<long>(nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_user_repairs_praise", x => x.Id);
            //    });

            //migrationBuilder.CreateTable(
            //    name: "Wy_work_evaluate_info",
            //    columns: table => new
            //    {
            //        Id = table.Column<int>(nullable: false)
            //            .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
            //        Eval_num = table.Column<int>(nullable: false, defaultValue: 0),
            //        Openid = table.Column<string>(nullable: true),
            //        Score = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
            //        TenantId = table.Column<int>(nullable: true),
            //        Totel_score = table.Column<decimal>(type: "decimal(18,2)", nullable: false)
            //    },
            //    constraints: table =>
            //    {
            //        table.PrimaryKey("PK_Wy_work_evaluate_info", x => x.Id);
            //    });
        }
    }
}
